package jp.co.hcs.attendancemanagement.data.dao;

import java.sql.SQLException;
import java.util.List;

import jp.co.hcs.attendancemanagement.data.entity.EmployeeMaster;
import jp.co.hcs.attendancemanagement.data.entity.ex.EmployeeMasterExample;
import jp.co.hcs.attendancemanagement.inputdailyattendance.logic.dto.AttendanceSettingInitDTO;
import jp.co.hcs.attendancemanagement.inputdailyattendance.logic.dto.DailyWorkingActualResultDTO;
import jp.co.hcs.attendancemanagement.inputdailyattendance.logic.dto.EmployeeCompanyDTO;
import jp.co.hcs.attendancemanagement.inputdailyattendance.logic.dto.TimeSettingInitDTO;
import jp.co.hcs.attendancemanagement.inputtableb.logic.dto.EmployerInfoDTO;

public interface EmployeeMasterDAO extends BaseDAO{
    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table tb5_shain_master
     *
     * @ibatorgenerated Wed Mar 07 22:22:22 GMT+07:00 2012
     */
    int countEmployeeMasterByExample(EmployeeMasterExample example) throws SQLException;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table tb5_shain_master
     *
     * @ibatorgenerated Wed Mar 07 22:22:22 GMT+07:00 2012
     */
    int deleteEmployeeMasterByExample(EmployeeMasterExample example) throws SQLException;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table tb5_shain_master
     *
     * @ibatorgenerated Wed Mar 07 22:22:22 GMT+07:00 2012
     */
    int deleteEmployeeMasterByPrimaryKey(String employeeId) throws SQLException;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table tb5_shain_master
     *
     * @ibatorgenerated Wed Mar 07 22:22:22 GMT+07:00 2012
     */
    void insertEmployeeMaster(EmployeeMaster record) throws SQLException;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table tb5_shain_master
     *
     * @ibatorgenerated Wed Mar 07 22:22:22 GMT+07:00 2012
     */
    void insertEmployeeMasterSelective(EmployeeMaster record) throws SQLException;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table tb5_shain_master
     *
     * @ibatorgenerated Wed Mar 07 22:22:22 GMT+07:00 2012
     */
    List<EmployeeMaster> selectEmployeeMasterByExample(EmployeeMasterExample example) throws SQLException;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table tb5_shain_master
     *
     * @ibatorgenerated Wed Mar 07 22:22:22 GMT+07:00 2012
     */
    EmployeeMaster selectEmployeeMasterByPrimaryKey(String employeeId) throws SQLException;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table tb5_shain_master
     *
     * @ibatorgenerated Wed Mar 07 22:22:22 GMT+07:00 2012
     */
    int updateEmployeeMasterByExampleSelective(EmployeeMaster record, EmployeeMasterExample example) throws SQLException;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table tb5_shain_master
     *
     * @ibatorgenerated Wed Mar 07 22:22:22 GMT+07:00 2012
     */
    int updateEmployeeMasterByExample(EmployeeMaster record, EmployeeMasterExample example) throws SQLException;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table tb5_shain_master
     *
     * @ibatorgenerated Wed Mar 07 22:22:22 GMT+07:00 2012
     */
    int updateEmployeeMasterByPrimaryKeySelective(EmployeeMaster record) throws SQLException;

    /**
     * This method was generated by Apache iBATIS ibator.
     * This method corresponds to the database table tb5_shain_master
     *
     * @ibatorgenerated Wed Mar 07 22:22:22 GMT+07:00 2012
     */
    int updateEmployeeMasterByPrimaryKey(EmployeeMaster record) throws SQLException;
    
    EmployerInfoDTO getEmployerInfo(String employerCode) throws SQLException;
    EmployeeCompanyDTO getEmployeeCompanyInfoDTO(String employeeId) throws SQLException;
    
}